1.Why you need a source qualifier transformation?
The source qualifier transformation converts the source data types into informatica native data types.
2.What are the different tasks a source qualifier can do?
1)Join two or more tables originating from the same source (homogeneous sources) database.
2)Filter the rows.
3)Sort the data
4)Selecting distinct values from the source
5)Specify a pre-sql and post-sql
6)Create custom query
3.What is a code page in Informatica?
The code page is used to specify the character encoding.We have to select appropriate code page based on the source data. You can set it in both source level as well as target FF. For example if the source contains Japanese,turky etc., we have to use corresponding code page from the list in order to make sure informatica read data properly.
4.How many tasks are there in informatica?(TCS)
1. Assignment Task
2. Command Task
3. Control
4. Decision
5. Email
6. Event-Raise
7. Event- Wait
8. Session
9. Timer
10.link Task
5.When will you use SQL override in a lookup transformation?
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
6.why we are using surogate key in real time give me explanation?(TCS)
Mainly we r using the maintain the historical data.and we
can get the data diffrent sources so we can idetified the
every record.
7.Whats the difference between $, $$, $$$
$ - session variable
$$ - mapping parameter & variable
$$$ - system variable
8.In oracle write query yourname+1 from dual
9.How to generate the HTML output using Informatica.
Use java transformation .this option is available in ver 8.1
also from shellscripting.
10.Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9.(Accenture)
The source qualifier transformation converts the source data types into informatica native data types.
2.What are the different tasks a source qualifier can do?
1)Join two or more tables originating from the same source (homogeneous sources) database.
2)Filter the rows.
3)Sort the data
4)Selecting distinct values from the source
5)Specify a pre-sql and post-sql
6)Create custom query
3.What is a code page in Informatica?
The code page is used to specify the character encoding.We have to select appropriate code page based on the source data. You can set it in both source level as well as target FF. For example if the source contains Japanese,turky etc., we have to use corresponding code page from the list in order to make sure informatica read data properly.
4.How many tasks are there in informatica?(TCS)
1. Assignment Task
2. Command Task
3. Control
4. Decision
5. Email
6. Event-Raise
7. Event- Wait
8. Session
9. Timer
10.link Task
5.When will you use SQL override in a lookup transformation?
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
6.why we are using surogate key in real time give me explanation?(TCS)
Mainly we r using the maintain the historical data.and we
can get the data diffrent sources so we can idetified the
every record.
7.Whats the difference between $, $$, $$$
$ - session variable
$$ - mapping parameter & variable
$$$ - system variable
8.In oracle write query yourname+1 from dual
9.How to generate the HTML output using Informatica.
Use java transformation .this option is available in ver 8.1
also from shellscripting.
10.Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9.(Accenture)
Informatica 7x to 9x cannot be upgraded directly.You first
need to upgrade to 8x.
need to upgrade to 8x.
Comments
Post a Comment