how will u take the data from clint server and next what u
do in datamodeling what u will u do
in staging area what u will u do next what u are doing
please give the step by step by process
No Answer is Posted For this Question
Be the First to Post Answer
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.
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
how do u tune queries?
what is session override?
enterprise datawarehouse your project phase by phase explain?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
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 any one explain about dataflow in the informatica project for bank domain....thanks is advance
How you count the number of records available at your source?
Explain about the concept of mapping parameters and variables ?
What is the difference between unicode & ascii mode data movement in informatica?