Answer Posted / malathi
Stopping a session task means the server stops reading data.
Abort has timeout of 60 sec , If the server is not finished
processing and committing data by the timeout ,the threads
and process assosiated with the sessions are killed.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What does role playing dimension mean?
can we override a native sql query within informatica? How do we do it?
What is meant by LDAP users?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is Index Caches size?
can we override a native sql query within informatica? Where do we do it?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the different lookup cache(s)?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to update or delete the rows in a target, which do not have key fields?
what is degenerated dimension?
How to join three sources using joiner? Explain though mapping flow.