what are the enhancements made to Informatica 7.1.1 version
when compared to 6.2.2 version?
Answer / shashiall
lookup on flat file in informatica7.1
no such provision in 6.1
union all trnasformation in 7.1 not in 6.1
transaction control tranformation not in 6.1
file reposioty in 7.1
Except to previous points.........
1. PMCMD: By using this option we can use parameter file at
command prompt. Why this needed suppose we are using more
than on parameter file, in such case we have to change the
parameter file in session properties. By this option u can
run from command prompt by changing parameter file, no need
to go to session properties.
2. Test load: we can test the load by taking the specified
no. of records.
Is This Answer Correct ? | 1 Yes | 0 No |
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
in a table it has 200 rows the query is select 150 from tablename.whats the output
What is Micro Strategy? Why is it used for?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to load time dimension?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Please let me know how to make encryption and decryption with example?
What are the different types of transformation available in informatica.
What is power play plug in?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How can we get multiple output values using an unconnected lookup transformation?