How You Pull the records on daily basis into your ETL Server.
Answers were Sorted based on User's Feedback
Answer / munireddy
uning incremental/delta/cdc..
for this we have so many logics some of them are..
using mapping level variable
using control table and ....
| Is This Answer Correct ? | 2 Yes | 0 No |
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
What is IQD file?
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
how we can update a target table without update strategy and update override?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Can anyone briefly describe abt audit table loading?
What are the Differences between connected and unconnected lookup?
what is Active lock explain
Why the workflow is failed after running two hours in informatica?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6