How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
- 0 Answers
- 918 Views
- Informatica, I also Faced
- E-Mail Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the differences between source qualifier and joiner transformation?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
What is primary and backup node?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
what type of problem you faced insales project or insurance project
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
How to read data from flat file source if the data is in paragraph format?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Teradata 
