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.
can any tell me procedure.
- 2 Answers
- 7697 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jay
SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2
First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / mari ilavarasi
Using router transformation we can send half of the records
in one target and rest of the records will be inserted into
another target based on conditions.
| Is This Answer Correct ? | 6 Yes | 3 No |
Explain what is informatica metadata and where is it stored?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How will the document be delivered to me?
What is the scenario which compels informatica server to reject files?
what is mean by throghput? in informatica
What do you mean by worklet?
How to read data from flat file source if the data is in paragraph format?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Briefly describe lookup transformation?
What are the different options used to configure the sequential batches?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
How to recover sessions in concurrent batches?
Teradata 
