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
- 15032 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Differences between version 7.x and 8.x.
Which development components of informatica have the highest usage?
What is standalone command task?
What is parallel processing in informatica?
How is union transformation utilized?
Do you find any difficulty while working with flat files as source and target?
How can you validate all mappings in the repository simultaneously?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Enlist the various types of transformations.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What does “tail –f” command do and what is its use as an Informatica admin.
can anyone suggest best free Talend data integration training online
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
