Interested to Buy Any Domain ? << Click Here >> for more details...
Flat file heaving 1 lack records and I want to push 52000
records to the target?
- 7 Answers
- 15364 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Answer / tadikonda
using test load option we can specify particular no of records
| Is This Answer Correct ? | 1 Yes | 4 No |
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 |
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
How to merge First Name & Last Name?
What is status code in informatica?
write a query for how to eliminate the duplicate rows without using distinct?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
How the informatica server increases the session performance through partitioning the source?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Teradata 
