1)what is the use of bottlenecks in informatica.
2)where we are use shellscripting.
3)what meant by informatica.
Answer / urs
1) Following are the some of bottlenecks in informatica..
(i) source bottlenecks
(ii)Target bottlenecks
(iii)Mapping bottlenecks
(iv) system bottlenecks
3)Informatica is one of most popular ETL tool...it will extract the data from the different sources and it will transform the data as per business logic and then it will load the data into different targets..
| Is This Answer Correct ? | 1 Yes | 0 No |
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is an expression transformation?
What is meant by LDAP users?
Please let me know how to make Data masking in informatica..
Partition, what happens if the specified key range is shorter and longer
How will you convert rows into columns or columns into rows
In a sequential batch can you run the session if previous session fails?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
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?
When do you use sql override in a lookup transformation?
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?