Answer / usha

By using Sequence Generator transformation.

in Sequence Generator transformation we shoud set

start value =1
cycle should enable
end value = 3
increment value=1

in router we should give condion as
next value=1 for 1st group
next value=2 for 2nd group
next value=3 for 3rd group


S-->SQ--> seq-->rout--> Target1
Target2--> Target3

Answer / sanjay

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

Answer / kns

source--->source qualifier-->sequence gen(we want to
reset)--->expression(decode)---->router(conditions)--->targets

Answer / cool buddy

take the rank T/R(take no.of ranks=4)and the take router t/r
in that give conditions as 1)rankindex=1,2)rkindx=2 etc.,


i think this will do .

Answer / sushma

Source ---> SQ ---> Expression ---> Router ---> Targets

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

What is the difference between a repository server and a powerhouse?

0 Answers  

In Which scenario did u used Incremental loading?

2 Answers  

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

Slowly changing dimensions, types and where will you use them

0 Answers  

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

Explain lookup transformation in informatica

0 Answers   Informatica,

What is DTM process?

4 Answers  

What are the new features in Informatica 5.0?

1 Answers  

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,