what are the reusable tasks in informatica ?
- 11 Answers
- 50991 Views
- CTS, HP, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / hari
Session Task,
Email Task,
Command Task
Worklet
| Is This Answer Correct ? | 10 Yes | 2 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.
which one is better performance wise joiner or look up
Explain direct and indirect flat file loading (source file type) - informatica
What is a filter transformation?
Partition, what happens if the specified key range is shorter and longer
How to partition the Session?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the need of etl tools?
What is the benefit of session partitioning?
How can one identify whether mapping is correct or not without connecting session?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Quickly characterize reusable change?
is it possible to index the data in cache of lkp transformation ?
How to extract sap data using informatica?
What's the layout of parameter file (what does a parameter file contain?)?
