Interested to Buy Any Domain ? << Click Here >> for more details...
i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2.
- 3 Answers
- 7277 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / akash
By using Router Transformation
SQL Server : (id%2 = 0 or 1)
Oracle : mod(id,2) = 0 or 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to elaborate tracing level?
Define Pmrep command?
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 ?
Under which circumstances, informatica server creates reject files?
Design time, run time. If you don't create parameter what will happen
How to update or delete the rows in a target, which do not have key fields?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is the -ve test case in your project.
Define pmcmd command?
What is a predefined event?
Explain the difference between a data warehouse and a data mart?
Where is metadata stored?
What are the different types of olap? Give an example?
tell me 5 session failure in real time how can you solve that in your project?
