Flat file heaving 1 lack records and I want to push 52000 records to the target

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Flat file heaving 1 lack records and I want to push 52000
records to the target?

Question Posted / shravan.cap

7 Answers
13034 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Flat file heaving 1 lack records and I want to push 52000 records to the target?..

Answer / pushpa

the answer number 5 for relational database objects only.
if the source is flat file we don't generate any SQL query in
the source qualifier.
then we are using the following way,
seqgen
|
sd-->sq-->expr-->filter--> td.
in the filter condition expression we take nextval<=52000.

Is This Answer Correct ?

12 Yes

0 No

Flat file heaving 1 lack records and I want to push 52000 records to the target?..

Answer / praveen kumar pendekanti

do the mapping as follows

source->source Qualifier->Expression->what ever u want and
final load to target.

Take sequence Generator....In Expression take one port as
Flag and connect the nextval to that port(Nextval port in
sequence generator) start nextval from one and use filter
transformation and use how many records u want.... and then
connect to Target........

Is This Answer Correct ?

8 Yes

0 No

Flat file heaving 1 lack records and I want to push 52000 records to the target?..

Answer / rajkumar_bachu

I think this can be handle through unix. If your source file
contains more than 52k records we can use if statment in
script to take first 52k records from the file by using the
head command and pass into other file and use this file as
your source.

Is This Answer Correct ?

3 Yes

0 No

Flat file heaving 1 lack records and I want to push 52000 records to the target?..

Answer / tadikonda

IF IT IS A FILE

Take one variable with the name $$count at mapping variable
level
Mention the initial value for that $$count=0(For every
record it will increment the count value by 1)

source-sq-Expression-Filter-Target

in that expression just take one o/p port in that
o_count=SetCountVariable($$Count)

Is This Answer Correct ?

3 Yes

2 No

Flat file heaving 1 lack records and I want to push 52000 records to the target?..

Answer / balu

source-->source qualifier-->sequnce generator-->expression--
>filter-->taget

in expression take one output port for generating sequence
after that in filter put the filter condition as sequence
numm <=50000

Is This Answer Correct ?

1 Yes

0 No

Flat file heaving 1 lack records and I want to push 52000 records to the target?..

Answer / tadikonda

using test load option we can specify particular no of records

Is This Answer Correct ?

1 Yes

4 No

Flat file heaving 1 lack records and I want to push 52000 records to the target?..

Answer / pushpa

you have 100000 records and you want to load 52k records in
the target. then,
source definition--> source qualifier-->target definition.
open source qualifier properties select SQL query,in that
field generate the query with WHERE clause rownum<=52000. and
run the session.

Is This Answer Correct ?

6 Yes

20 No

Post New Answer