I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
1711What are the types of schemas we have in data warehouse and what are the difference between them?
944Post New Informatica Questions
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is lookup transformation?
Quickly characterize reusable change?
How to load the data from a flat file into the target where the source flat file name changes daily?
wf dont have integration severances how you can run?
What is a dimensional model?
What is dimensional table?
What does role playing dimension mean?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to start a workflow using pmcmd command?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
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
design of staging area?