Interested to Buy Any Domain ? << Click Here >> for more details...
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target?
I am new to Informatica,can anybody suggest me the idea?
- 2 Answers
- 4486 Views
- I also Faced
- E-Mail Answers
Answer Posted / naveenkumar
drag and drop the source to the mapping and connect the expression transformation.variable port to an expression transformation
v_count=v_count+1
o_count=v_count
and exp transformation to connect the router transformation groups
column name<=25 lks
column name>=26 lks and column name<=50 lks
column name>=51 lks and column name<=75 lks
column name>=76 lks and column name <=1 cros
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
can u give example for factless fact table
What are data-driven sessions?
What is an expression transformation?
What is a repository manager?
Do you find any difficulty while working with flat files as source and target?
What is decode in static cache?
What is sq transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
what is size of u r database?
Can we override a native sql query within informatica?
What does role playing dimension mean?
What can we do to improve the performance of informatica aggregator transformation?
can anyone explain me about retail domain project in informatica?
How to partition the Session?
