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
- 15035 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
Define enterprise data warehousing?
What do you understand by SOA of Informatica?
Where do we use mapping variables in informatica?
how tokens will generate?
What does role playing dimension mean?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Define sessions in informatica etl?
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?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain the types of lookup transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is difference between a gateway node and worker node?
What is expression transformation?
Explain target update override in informatica
What are the types of lookup transformation?
