Interested to Buy Any Domain ? << Click Here >> for more details...
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
- 3 Answers
- 26107 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / subhash
No, you can't apply SCD2 on flat files.
| Is This Answer Correct ? | 35 Yes | 6 No |
Post New Answer View All Answers
Which is the t/r that builts only single cache memory?
How identifying bottlenecks in various components of informatica and resolving them?
Explain load alternative records / rows into multiple targets - informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How many ways are there to do 'remove duplicate records in informatica'?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Why update strategy and union transformations are active? Explain with examples.
How do you set a varible in incremental aggregation
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Design time, run time. If you don't create parameter what will happen
Differences between connected and unconnected lookup?
What is the cumulative sum and moving sum?
pmscmd startworkflow -sv
