suppose we have 1 to 10 records.In router transformation we
had given two condition
A>= 5
A<=5
then what will be the output?
Answers were Sorted based on User's Feedback
Answer / mike
If you create two groups in the router transformation and
you want to load the records in to two target tables then
src-->srcq--->router-->/t1
\t2..The records which meet the
condition in the first group will pass in to the T1 and the
records which meet the condition in the second group will
pass in to the T2...i mean to say all the records that
matches the condition will come as an output
correct me if i was wrong
| Is This Answer Correct ? | 7 Yes | 6 No |
What is active and passive transformation?
What is the surrogate key?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How do you implement unconn. Stored proc. In a mapping?
Under what condition selecting sorted input in aggregator may fail the session?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
explain different levels in pushdown optimization with example?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?