following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?

Answers were Sorted based on User's Feedback



following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd ..

Answer / suresh

Use Sequence generator
In sequence generator set the properties
start value 1
end value 3
cycle yes
conn sequence generator to exp and test in router

Is This Answer Correct ?    10 Yes 1 No

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd ..

Answer / gangadhar

Hi suresh you are 50% current

sq-->expression-----> rooter----->t1
seqno/ ------t2
-------t3

drag the all columns to expression create one new column this column connect sequence generator connect NEXT VALUE
In sequence generator set the properties
start value 1
end value 3
cycle yes

later exp-->router connect hear create 3 groups
group1-NEXT VALUE=1
group2-NEXT VALUE=2
group3-NEXT VALUE=3

first group connect to T1
second group connect to t2
third group connect to t3

is 100% correct

Is This Answer Correct ?    4 Yes 0 No

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd ..

Answer / rakesh

use a Sequence Generator to generate a column NUM
in Router 1st Group: MOD(NUM,3)=1
2nd Group: MOD(NUM,3)=2
3rd Group: MOD(NUM,3)=0

Im not sure about MOD format, but this idea will workout..

Is This Answer Correct ?    6 Yes 3 No

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd ..

Answer / uppala chary

suresh answer is correct

Is This Answer Correct ?    0 Yes 0 No

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd ..

Answer / venkat

->Connect desired columns to Expression and create custom
colum.
->Use Sequence Gen inorder to generate cyclic values 1,2,3
logic :start with 1 ,increment by 1 and end with 3
Cycle -Yes.
->Connect it to Custom column
->Use Router to rout coresponding group
Group1 -Value1- Target1
Group2 -Value2- Target2
Default-Value3- Target3

Is This Answer Correct ?    0 Yes 0 No

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd ..

Answer / triveni

startvalue=1
endvalue=3
cycle=yes seequencegenerator
\
source->sq->expression->router->target1
->target2
expression->copy nextval port to expression
router->mod(seq,3)=1
mod(seq,3)=2
mod(seq,3)=0

Is This Answer Correct ?    0 Yes 0 No

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd ..

Answer / omkar

use router transformation
in that give condition 1st row id to 1st target
and so..

Is This Answer Correct ?    0 Yes 9 No

Post New Answer

More Informatica Interview Questions

Differentiate between source qualifier and filter transformation?

0 Answers  


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


What is a command that used to run a batch?

2 Answers  


How can you validate all mappings in the repository simultaneously?

0 Answers  


Is informatica power center designer has 64 bit support?

1 Answers  






In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,


what is plsql table?

2 Answers  


generate Unique sequence numbers for each partition in session with Unconnected Lookup ? Hi All, Please help me to resolve the below issue while Applying partitioning concept to my Session. This is a very simple mapping with Source, Lookup , router, and target. I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update. while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table. The above flow is working fine from last one year. Now I wish to apply the Partitioning concept to the above floe(session) At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source) at Target I used 4 passthrough Partitions. it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice. In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row. 2nd row is coming from 1st partition and generated the sequence number 2 for that row 3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row) the issue is becuase of generating the same sequence numbers twice for different partitions. Can any one Please help me to resolve this issue. While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data. Regrads, N Kiran.

2 Answers   Tech Mahindra,


i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,


What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  


My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,


Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


Categories