Answer Posted / srinu
make required column as primary-forign key relation then add
fields wt do u want
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the mapping variable usage example in informatica
Explain the different kinds of facts.
Scheduling properties,whats the default (sequential)
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How do you handle two sessions in Informatica
Differentiate between sessions and batches?
scenario where i can use only concurrent execution of workflow.
Enlist the advantages of informatica.
How do you convert single row from source into three rows into target?
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 the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How can repository reports be accessed without sql or other transformations?
State the differences between sql override and lookup override?
Explain informatica architecture - version 8 / 9
How many number of sessions can one group in batches?