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 |
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
How to generate sequence numbers without using the sequence generator transformation?
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
What is dimensional table?
According to his methodology what all you need before you build a datawarehouse
How to improve the session performance in informatica?
How the informatica server sorts the string values in Rank transformation?
What are the types of data that passes between informatica server and stored procedure?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
What happens if we dont select data driven option?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?