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
- 15293 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 |
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
how do the project develops? pls specify right from the start to end in step by steps.
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
Can i create a lookup table without cache.
Does an informatica transformation support only aggregate expressions?
Where is metadata stored?
What are differences between Informatica 7.1 and 6.1
how can u tune u r informatica mapppings
What is the fact table?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
What is xml source qualifier transformation in informatica?
Teradata 
