normalizer transformation
Answers were Sorted based on User's Feedback
Normalizer transformation is an active. It is used to import
the cobol sources. The cobol source is associated with
normalizer transformation.
It is used to single input record to multiple record is
known as data pivot.
Is This Answer Correct ? | 3 Yes | 0 No |
Normalizer transformation is an active. It is used to import
the cobal sources.
data pivot is a process single input records into multiple data records
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveenkumar
normalization trans is active trans .normalization trans is define horizontal data pivot.
the data pivot is a process of converting the single input records in multiple data records
Is This Answer Correct ? | 0 Yes | 0 No |
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
if soource is having 10 records how will u insert 20 records to target
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
Explain sessions?
What is a joiner transformation and why it is an active one?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
what r the transformations that r not involved in mapplet?
Why sorter is an active transformation?
what is left outer join?