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 43367

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

 4 30111

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 15743

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 6908

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

 10 31205

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

 2 7001

What are the uses of a Parameter file?

 3 11793

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

 3 13608

when we dont use aggregator in mapping ?

 2 5459

How many joins in Informatica

 5 22078

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

 3 8103

What is router transformation

 4 5342

How to eliminate duplicates in FF and oracle both

 3 5710

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

 2 6235

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 7510

Post New CSC Informatica Interview Questions


CSC Informatica Interview Questions


Un-Answered Questions

Tell me about Optical Fiber.

530

How can you reduce noise of an image?

19

What is the right function in excel?

240

What is the range of uv & vis lamp in spectrophotometer?

586

What are your opinions on the role of technology in the banking sector?

504




why we have to particulary use ACB for below ratings,even available of MCB,MCCB with that range ?

2395

Is asp.net is a programming language?

424

What is Latency?

57

How can we use mapping variables in informatica? Where do we use them?

551

What is the maximum value that can be stored in s9(8) comp?

542

What is the difference between system.out ,system.err and system.in?

526

How does asp.net work?

484

What is unboundlocalerror in python?

423

Do you know what dependencies does bootstrap require for it to work properly?

3

Are you ready to relocate with your immediate family as a new employee?

1144