Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 41269

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

4 29226

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 14663

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 6356

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

10 29955





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

2 6439

What are the uses of a Parameter file?

3 11112

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

3 12738

when we dont use aggregator in mapping ?

2 4991

How many joins in Informatica

5 21200

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

3 7509

What is router transformation

4 4722

How to eliminate duplicates in FF and oracle both

3 5125

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

2 5805

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 6978

Post New CSC Informatica Interview Questions




CSC Informatica Interview Questions


Un-Answered Questions

Why do you want to join iNAUTIX?

441


What are the components of r functions?

35


what is Client launching ?

1250


What is tcode se16. For what is it used. Explain briefly?

323


What are some best practices that you should follow when writing test cases?

384






What type of work environment is suitable and which environment you hate/is frustrating?

467


which one is more flexibility and reliability and durability asp.net (VS)php which one is best and which one we do nice to create dynamic websites

1382


Which specifications does wcf follow?

285


What is database bounce?

313


What is use of static in java?

275


What does t sql mean?

298


Difference between plan cost, Actual cost and target cost.

2238


Explain the various colour harmonies with the help of diagrams.

3


What is meant by relay & co-ordination at substation engineering ?

1585


Why is it called a slug?

101