Sunday, June 12, 2011

Half Records to one Target Half to another -- If Source is a Flat File ..

If your Source is FLAT FILE..


Half_Half_Loading_Flatfile.jpg
Design the two pipelines as shown above..
First Create a Mapping Variable $$Rec_Count


Second Pipeline

> Idea is to pick up Count of Rows using Aggrigator transformation using COUNT() function..... CNT = COUNT(*)
> Using Exp-Tr that value will be assigned to Mapping variable using SETVARIABL($$Rec_Count, CNT)
> Filter Tr is used with conditon set as FALSE.. becoz no records need to be loaded into target.
Here our idea is to find out RowCount and assigingin it to Mapping variable only..


First Pipeline


> In the Exp-Tr create a new port Rec_count (variable port) and increment it with 1 -- Rec_count + 1
This is becz inorder to generate seqnum with out using Seq-Gen-Tr ...
> Create o/p port  O_Rec_count = Rec_count
> Pass all ports to Router .. Create a group  and conditon as

Rec_Count <= ($$Rec_Count / 2)

Here $$Rec_Count is mapping variable.....
> Connect respective groups to targets.. mean default group to second target..

NOTE :  In this example Second pipeline should execute first so set ..
Target Load Order  : Second Pipeline first  -- First Pipeline next

13 comments:

  1. Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
    Informatica Online Training I have taken this course from Attain Technologies. Thay covered all the real time scenarios and their training way was very good approach is very much understandable
    Contact them on given contact number is +91 9052820000, +1 2092073642, Email:contact@attainonlinetraining.com
    Web: http://attainonlinetraining.com/it-informatica-online-training.html

    ReplyDelete
  2. This is nice article and thanks share with us.we are providing Informatica online taining.

    ReplyDelete
  3. The information which you have provided is very good and easily understood.
    It is very useful who is looking for Informatica Online Training.

    ReplyDelete
  4. This is the information that I was looking for and let me tell you one thing that is it is very useful for who is looking for INFORMATICA.

    ReplyDelete
  5. Really good piece of knowledge, I had come back to understand regarding your website from my friend Sumit, Hyderabad And it is very useful for who is looking for INFORMATICA.

    ReplyDelete
  6. Thanks for providing the best information it's very useful for INFORMATICA learners.we also provide the best INFORMATICA Online Training.

    ReplyDelete

  7. Thanks for providing the best information it's very useful for Informatica learners.123trainings also provide the bestInformatica Online Training you can see free demo Informatica Online Training Demo in Hyderabad India

    ReplyDelete
  8. This is the information that I was looking for and let me tell you one thing that is it is very useful for who is looking for INFORMATICA .Attain technologies provides best Informatica Online Training.

    ReplyDelete
  9. I Appreciate it Itis good stuff and it is very helpful for us.Biginfosys provides best online Informatica training .

    ReplyDelete
  10. Do You Know How To Integrate The Data By Using Informatica ETL Tool?, Learn at

    http://www.dwbiadda.com/course/informatica-online-training/

    ReplyDelete
  11. It was so nice article and useful to Informatica learners. we also provide Informatica Course online training our Cubtraining is leader in providing Software Training

    ReplyDelete
  12. Info is very good..

    http://www.tekclasses.com/

    ReplyDelete