Answer Posted / krishnakanth.ch
There are many ways....
1) Using the sql override in the source qualifier. To find
the even and odd. Add another column to flag the even and
odd.Like
select ID,decode( id/2,0,'E','O') FLAG FROM TABLE_NAME;
Using the router we can send them into two seperate target
tables.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is update strategy transform?
What are the advantages of using informatica as an etl tool over teradata?
Differentiate between Load Manager and DTM?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the Process to creating lookup transformation in informatica
What the difference is between a database, a data warehouse and a data mart?
what is song in infrmatica...?
Explain the shared cache and re-cache?
Which transformation is needed while using the Cobol sources as source definitions?
how we can load rejected record's at run time?(not through bad files)
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is option by which we can run all the sessions in a batch simultaneously?
What are the reusable transformations?
Tell me about MD5 functions in informatica
Differentiate between a repository server and a powerhouse?