IF U WANT LOAD 7 RECORDS FROM SOURCE TO TARGET, WE CAN USE SEQUENCE GENERA

i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?

Question Posted / amedela chandra sekhar

7 Answers
13719 Views
L&T, I also Faced
E-Mail Answers

Answer Posted / amedela chandra sekhar

IF U WANT LOAD 7 RECORDS FROM SOURCE TO TARGET,
WE CAN USE SEQUENCE GENERATOR T/R
CURRENT VALUE =0
END VALUE =7
RESET ENABLE
THEN DRAG THE NEXTVAL PORT TO EXP T/R
CREATE ONE OUTPUT PORT GIVE THE CONDTION LIKE NEXTVAL =7.

PLZ LET ME IF ANY WRONG

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

where to store informatica rejected data?

1078

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1063

What are the main features of Oracle 8i with context to datawarehouse?

2094

Explain pushdown optimization $pushdownconfig parameter - informatica

1116

What is the difference between a connected look up and unconnected lookup?

952

Define mapplet?

995

How to Create a folder using pmrep command?

1151

Explain sessions?

1027

What is InformaticaPowerCenter?

1112

How can we use mapping variables in informatica?

1036

What is lookup transformation?

1021

Explain pmcmd command usage in informatica

1105

What are the differences between source qualifier and joiner transformation?

1033

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3848

What are the components of workflow manager?

1071