scenario
Answer / prasad_bestha
source table
col1 col2
101 1-a
102 1-a,2-ab
103 1-a,2-ab,3-abc
target table
col1 col2 col3
1 101 a
2 102 a
3 102 ab
4 103 a
5 103 ab
6 103 abc
Is This Answer Correct ? | 0 Yes | 0 No |
How do we implement materialized view?when to use materialized view?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Differentiate between reusable transformation and mapplet.
can every transfomation reusable?how?
How to load query faster,so that It will take less time to load?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
How you know when to use a static cache and dynamic cache in lookup transformation?
waht is dataware house
Why we use stored procedure transformation?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What is an expression transformation in informatica?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??