Answer Posted / reddy
surrgate key is not used for the bussiness
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain what is informatica metadata and where is it stored?
How will the document be delivered to me?
What the difference is between a database, a data warehouse and a data mart?
What are the different types of olap? Give an example?
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
can you please explain me pre session and post session options?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Make a note of the quantity vaults made in informatica?
What is the surrogate key?
State the differences between sql override and lookup override?
What is the difference between informatica 7.0 and 8.0?
How many number of sessions can one group in batches?
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.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.