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 37110

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

4 27671

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 13278

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 5336

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

10 27188

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

2 5603

What are the uses of a Parameter file?

3 9909

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

3 11020

when we dont use aggregator in mapping ?

2 4253

How many joins in Informatica

5 19630

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

3 6462

What is router transformation

4 3721

How to eliminate duplicates in FF and oracle both

3 4238

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

2 4897

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 5855

Post New CSC Informatica Interview Questions

CSC Informatica Interview Questions

Un-Answered Questions

What is meant by publisher and why we are using it in Dynamics CRM Solutions?


Difference b/w collectionView & uitableview?


which are the member types which seu supports?


hi sir, i completed my GNIIT from NIIT. i recently joined in IT company for Testing(manual) on JD EDWARDS.So,i wanna to ask that after taking 1yr experience can i able to do Testing .NET in another company.Pl i am confused pl send yours suggestion throw my email(


List the causes of vesico-vaginal fistulas?


Describe Memtable?


What is the difference between reader/writer and inputstream/output stream?


What are your short- term and Long- term goals?


What is the role of the current selections box in QlikView’s dashboard?


Explain what is the stack of autorelease pools. How autorelease pool work under the hood?


is it possible for different brand of H.V transformers to run or operate in parallel to each other? if so how much disturbance can this affact the H.V bus bar?


what is datamapping in hrms? i want detail information about API in hrms?


Explain the difference between the convertible and non-convertible debenture?


Difference between cassandra and mongodb?


What are the disadvantages of using google adsense?