Interested to Buy Any Domain ? << Click Here >> for more details...
1)what is the use of bottlenecks in informatica.
2)where we are use shellscripting.
3)what meant by informatica.
- 1 Answers
- 7210 Views
- CTS, I also Faced
- E-Mail Answers
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 generate sequence numbers without using the sequence generator transformation?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
write a query to retrieve the latest records from the table sorted by version(scd)
What are the joiner caches?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
What are the data movement modes in informatcia?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
How to load the data from people soft hrm to people soft erm using informatica?
wt is Dynamic lookup Transformation? when we use?how we use?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
Teradata 
