CSC Informatica Interview Questions Answers, CSC Placement Papers, CSC Technical, HR Interview Questions, CSC Aptitude Test Questions, CSC Campus Placements Exam Questions

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 48392

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

4 32460

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 18078

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 8372

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

10 34553

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

2 8489

What are the uses of a Parameter file?

3 13692

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

3 15231

when we dont use aggregator in mapping ?

2 6608

How many joins in Informatica

5 24071

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

3 9496

What is router transformation

4 7149

How to eliminate duplicates in FF and oracle both

3 7285

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

2 7361

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 9153

Post New CSC Informatica Interview Questions

CSC Informatica Interview Questions

CSC Informatica Interview Questions (18)

Un-Answered Questions

What is the $_ server php_self variable?

1019

What are the benefits of microsoft excel?

771

Is asp.net web forms dead?

1131

What task is 98% of the required work of a business analyst?

1054

How sap change request management is helpful?

If I is an integer variable, which is faster ++i or i++?

1080

How does closure work in swift?

815

give us one reason for why should we hire you?

1138

Can you explain remoting?

1046

What are internal and external commands in unix?

992

How would you design a gravity dam for holding back water?

1135

In Hadoop, which file controls reporting in Hadoop?

776

Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc

1172

1) What r the properties, Advantages & Disadvantages of each types of action? 2)When I can use this?

2042

Can you discuss the potential impact of emerging technologies, such as gene therapies or retinal implants, on ophthalmic practice?