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.

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........

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.

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)

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

Answer / tadikonda

using test load option we can specify particular no of records

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.

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

What is a parameter When and where do you them when does the value will be created

0 Answers  

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

How big was your fact table

0 Answers  

What are the different ways to implement parallel processing in informatica?

0 Answers  

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,