What are the different ways to deploy the code in informatica?
There are different ways to deploy code in Informatica.
1) If code needs to be deployed from DEV to TEST then Export XML of DEV workflow in the local directory and then connect to Test repository and import that XML in a TEST.
2)Create a deployment group of all objects that need to be deployed from one environment to another and then deploy that group to other environment
| Is This Answer Correct ? | 0 Yes | 0 No |
Compare etl & elt?
what is session partitioning?
Explain the key challenges that you face while performing etl testing.
Is apache nifi an etl tool?
what is pmrep command?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What do you understand by active and passive transformations?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what is a test load?
what are the facilities provided by OLAP to analytical users?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge