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. what is the procedure and whar t/r's are involved
and what is the mapping flow
- 4 Answers
- 11989 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vani
Can it be done in this way....
1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.
If i am wrong please tell me....
| Is This Answer Correct ? | 27 Yes | 4 No |
Post New Answer View All Answers
Did u used latest transformations of 8.6.0? for what?
Write the advantages of partitioning a session?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a joiner transformation?
Why sorter is an active transformation?
How does a rank transform differ from aggregator transform functions max and min?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Performance tuning( what you did in performance tuning)
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
wat are deployement groups in informatica, how it will be used for developers
What is aggregate cache in aggregator transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is powercenter on grid?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
