Sq-->Expression-->Router-->Target

One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?

Question Posted / sanjay

Answer Posted / sanjay

Sq-->Expression-->Router-->Target
| |
| v
v grp1--> col=1
mod(col,3) grp2--> col=2
Default

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Design time, run time. If you don't create parameter what will happen

1837

What the difference is between a database, a data warehouse and a data mart?

1156

How to call shell scripts from informatica?

1001

Describe data concatenation?

1085

What is lookup change?

1052

Explain the types of transformations?

1070

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1112

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2344

How can you generate reports in informatica?

1035

What is a sequence generator transformation?

1023

What is data caches/ index caches?

1107

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710

Explain what is informatica metadata and where is it stored?

1051

How to elaborate powercenter integration service?

1136

Explain in detail scd type 2 through mapping.

1046