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

TCS Informatica Interview Questions
Questions Answers Views Company eMail

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

 3 6115

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 5308

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

 5 11470

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

 8 10422

checkout and checkin in informatica 8.6

 3 18483

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

 5 8378

How to Join Tables my Source is having 15 table target is one?

 4 6738

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

 2 6777

Can we use unconnected lookup as dynamic lookup?

 5 15982

how did u understand business requirement?

 2 4820

What is the difference between writing a joiner query in ANSI style and THETA style?

 1925

can we use mapplet as starting n ending object in mapping

 2 4811

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

 1559

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 5876

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 6382

Post New TCS Informatica Interview Questions


TCS Informatica Interview Questions


Un-Answered Questions

What are the file formats supported by spark?

195

What is this keyword in C#?

588

How to treated with dry mouth?

471

Can we load and replicate data from one source system to multiple target database schemas of hana system? : hana sql script

58

What is a selector objective c?

1




what is the advantages and dis advantages of critical speed of turbine.

1648

How to rename a tablespace in oracle?

619

How BLObs act as SQL input parameters?

1217

What is the main function of url routing system in asp.net mvc? : asp.net mvc

502

What is nVision Tab? 

862

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

613

How do you secure your configuration files to be accessed remotely by unauthorized users?

627

What are common supply chain master data types?

139

How does pig work?

355

What is the command to compare two files in unix?

624