Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details
- 8 Answers
- 18850 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mike
target1
src-->sq-->seq gen-->rtr--> /
\
target 2
drag the source. create an sequence generator
transformation and then pass all the data to router create
two groups in the router transformation pass it to
target...You can give the condition in the router
transformation based on your requirement. if it is like odd
and even...you can use mod function in the router
transformation.
Mod function returns 0 passit to t2 and mod function
returns 1 pass it to t1
hope this works...correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
can u give example for factless fact table
How we can create indexes after completing the load process?
What are the uses of etl tools?
Quickly characterize reusable change?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
expain about the tune parameters?
Parameter and variable differences
What is Data Caches size?
How to generate sequence numbers?
Differentiate between source qualifier and filter transformation?
What is the fact table?
permutations of mapplet
Do you find any difficulty while working with flat files as source and target?
Explain what is informatica metadata and where is it stored?
What are the different lookup cache(s)?
