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. 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
  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 .Attain technologies provides best Informatica Online Training.

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

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

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

    ReplyDelete
  7. 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
  8. Info is very good..

    http://www.tekclasses.com/

    ReplyDelete
  9. Its very informative blog and useful article thank you for sharing with us , keep posting learn
    more about Informatica Online Course Hyderabad

    ReplyDelete
  10. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Best Devops Training in pune
    Data science training in Bangalore

    ReplyDelete
  11. Were a gaggle of volunteers as well as starting off a brand new gumption within a community. Your blog furnished us precious details to be effective on. You've got completed any amazing work!
    Selenium training in Chennai
    Selenium training in Bangalore
    Selenium training in Pune
    Selenium Online training

    ReplyDelete
  12. All the points you described so beautiful. Every time i read your i blog and i am so surprised that how you can write so well.

    Python Online certification training
    python Training institute in Chennai
    Python training institute in Bangalore

    ReplyDelete