In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
- 4 Answers
- 7511 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajkumar_bachu
By using Normalizer transformation we can normalize the data.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / gvmahesh
By using Sequencegenerator T/R we can normalize the
denormalized tables.
Because, By using SEQ T/R we can generate surrogatekey
column.then we can define that as Primarykey column.
| Is This Answer Correct ? | 0 Yes | 0 No |
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
What is tracing level and what are the types of tracing level?
If we set dd_insert in mapping and Delete in session properties what will happen.?
What are the informatica performance improvement tips
without dynamic lookup how to insert new rows and update existing rows?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
How do we implement materialized view?when to use materialized view?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
how to join the two flatfiles using the joiner t/r if there is no matching port?
What is depict expression change?
Teradata 
