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
- 14783 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Is it possible to revert a global repository to local one and why?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how to create user defined function (udf) in informatica
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is main use of mapplet?
how to load rows into fact table in data warehouse
Write the prerequisite tasks to achieve the session partition?
can we override a native sql query within informatica? How do we do it?
In which transformation you cannot drag ports into it?
Can we get 1st record through Informatica(without sequence number).
What is a snowflake schema?
Explain the difference between mapping parameter and mapping variable?
Explain how to import oracle sequence into informatica?
What is decode in static cache?
What are the measure objects?
