Answer Posted / jvdwhinfo
Using Seq. generator we can delete the desired record from
flat file.
Please let me know if you have any suggestions.
Thanks,
James
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is meant by active and passive transformation?
What is flashback table ? Advance thanks
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain why we use partitioning the session in informatica?
In warehouses how many schemas are there?
How do you load alternate records into different tables through mapping flow?
What are the different types of transformation available in informatica.
What is joiner change?
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.
What are junk dimensions?
Quickly characterize reusable change?
Can anyone tell me the new features in Informatica 9 Version?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Informatica settings are available in which file?
