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 11349

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 10280

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 11766

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

 2027

Explain your project of banking domian.

 1214

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

 980

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

 1831

On which transformations you created partitions in your project?

 758

Post New Cap Gemini Informatica Interview Questions


Cap Gemini Informatica Interview Questions


Un-Answered Questions

what is a constructor? What is a destructor?

520

How you attach search help to data element? : sap abap data dictionary

644

What is difference between mutable and immutable?

1

is it possible that on dealer of work contract can opt composition and non-composition both scheme in dvat?

1577

What is the asp.net control toolkit?

550




How do you play a powerpoint slideshow?

115

How to add more data to the testing table in ms sql server?

547

Into how many types acquired immunity is classified?

146

What is the difference between internal & external schema?

310

What is the function of 'selective deletion' tab in the manage contents of an infocube?

37

How you improve the performance of sql*loader? : aql loader

571

What is meant by Modularity ?

512

What is a tableau data sheet?

162

What are ng-include and ng-click directives in angularjs?

464

What is the candidate key used for?

622