Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Cap Gemini Informatica Interview Questions
Questions Answers Views Company eMail

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

 5 11578

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

 5 10471

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 11919

Partition, what happens if the specified key range is shorter and longer

 2062

Explain your project of banking domian.

 1249

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

 1032

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

 1894

On which transformations you created partitions in your project?

 796

Post New Cap Gemini Informatica Interview Questions


Cap Gemini Informatica Interview Questions


Un-Answered Questions

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.

1586

In Designing the rating & accessories of a MCCB how to choose the type of releases..means what is the basis for selecting, thermal magnetic, electromagnetic & microprocessr based releases

1652

Hello! I want to choose a software for verfication and validation. Can some one give me option for choosing software to test?

1683

Explain what does the protocol FTP do?

659

What is the difference between an element and a component in react?

181




How do you check formulas for errors in excel?

325

What are actions in mvc?

593

What are the different modes in hana studio that can be used for migration?

53

What is else if syntax?

716

Can you brief about the Data warehouse project you worked on?

1973

How do you determine if a binary tree is height balanced?

542

if thread a,b,c have Max,Min,Normal priorty what is N0. in below set they correspond to.Something like (2,0,1)

2237

how to calculate the length diamond shaped striupps in column

2238

Specify the different methods of hive?

426

How do I get my word document back to normal margins?

344