Answer / sajid hussain

Step1: After SQ transformation take Sequence Generator transformation and edit properties like, Start Value=1, Increment By=1, End Value=3 and check the Cycle.

Step2: Now take a Router transformation and drag all the ports from SQ transformation to Router, as well as drag the NEXT VAL port from Sequence Generator transformation to Router.

Step3: Create 3 group T1, T2 and T3 and for each group condition will be like T1 --> NEXTVAL=1, T2 --> NEXTVAL=2 and T3 --> NEXTVAL=3

Step4: Connect all the 3 targets and run the mapping.

Answer / naveenkumar

drag and drop the source to the mapping and connect the expression transformation.variable port to an expression transformation
v_count=v_count+1
o_count=v_count
and exp transformation to connect the router transformation groups
column name<=25 lks
column name>=26 lks and column name<=50 lks
column name>=51 lks and column name<=75 lks
column name>=76 lks and column name <=1 cros

How to elaborate powercenter integration service?

0 Answers  

---

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

What are the ETL tools available in DWH?

6 Answers   Mphasis,

---

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

---

How to partition the Session?

0 Answers   Informatica,

---

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

how to sort date field in infomatica?

2 Answers  

---