How can you change from reusable session into non-reusable
session.
Answer Posted / koti
by developing the session in work flow manager we can
achieve this...
| Is This Answer Correct ? | 7 Yes | 16 No |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
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 do you convert single row from source into three rows into target?
server hot-ws270 is connect to Repository B. What does it mean?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
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 is rank transformation?
What is the use of code page?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is pmcmd command?
Explain the tuning lookup transformation - informatica
Define enterprise data warehousing?
Why do we need informatica?