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




CSC Informatica Interview Questions
Questions Answers Views Company eMail

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

 14 38253

In real time scenario where can we use mapping parameters and variables?

 4 28113

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

 5 13624

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

 3 5513

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

 10 28154




How to generate a single mapping for both the historical and incremental load.

 2 5769

What are the uses of a Parameter file?

 3 10200

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

 3 11483

when we dont use aggregator in mapping ?

 2 4399

How many joins in Informatica

 5 20017

How to identify this row for insert and this row for update in dynamic lookup cache

 3 6725

What is router transformation

 4 3931

How to eliminate duplicates in FF and oracle both

 3 4376

If I am having 6 flat files in data. How can you load the data at a time

 2 5088

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 6133

Post New CSC Informatica Interview Questions




CSC Informatica Interview Questions





Un-Answered Questions

How many runtime resources that can be registered with single license?

1

Tell us a time you led a group of people, the primary challenges you faced and how you handled them?

1211

Why should we not hire you?

121

What is chaining in node.js?

13

What is app in sales force? : salesforce admin

7




What is control tables?

38

Dear Sir, Please advice to us; the description / specification data of Alstom Motor AC part number P/n.91420579P021, the specification: 3 Phase, Power rating: 11.5Hp, Revolutions: 860Rpm, Voltage rating: 460VAC, Frequency: 60Hz, Current Rating: 17A, Service factor: 0.82SF, class: F. (2 shaft MOTOR AC-Left and right). Regards Haryanto

1205

What is swelling?

1

What is ILDASM ?

93

What types of insulators are there?

72

When you will not automate testing?

85

What are the advantages of case class?

3

What is mqtt client?

40

Users come to you and they will be saying mail server is very slow, what are the necessary steps you will take to resolve this issue in Linux?

93

Are you using singleton in your code?

75