In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
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 |
Global and Local shortcuts. Advantages.
What is limitations of truncate and load option
can you avoid static cache in the lookup transformation? I mean can you
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
what we require for D.modelling?
How can you define user defied event?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
If we have lookup table in workflow how do you trouble shhot to increase performance?