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 44054

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

 4 30508

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 16039

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 7084

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

 10 31574

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

 2 7162

What are the uses of a Parameter file?

 3 11998

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

 3 13826

when we dont use aggregator in mapping ?

 2 5628

How many joins in Informatica

 5 22386

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

 3 8304

What is router transformation

 4 5608

How to eliminate duplicates in FF and oracle both

 3 5889

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

 2 6391

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 7784

Post New CSC Informatica Interview Questions


CSC Informatica Interview Questions


Un-Answered Questions

What is erythropoiesis?

312

what r the strategies & methodologies r u following in preperation of test cases based on usecase?

1599

What is the purpose of using break in each case of switch statement?

559

Hi Friend, I am sap SD consultant & want to learn SAP SD CIN part. there are four Pricing Procedure in SAP SDJINFAC: SALES FROM FACTORYJINEXP: EXPORT SALESJINDEP: DEPOT SALEJINSTK: STOCK TRANSFER But i want to know how to configure Table /Access Sequence /Condition / Pricing procedure/Determination of Pricing proceudre/ Condition record Plz help me with the configuration path of all 4 pricing proceudre of SAP SD CIN

1328

what is us staffing? describe the complete life cycle of the us staffing

3246




hi to all, i need a code.. in flight application 1.i need to login first then i need to insert 3 new orders... 2.i have to log out 3.i have to login again with different user 4.need to insert 2 new orders 5.then need to log out 6.then again login with different user 7.3 new orders create and log out 8.but we hv to do this using data table and actions please help me

1754

please give me different test scenario for uploading whatsapp status from gallery and camera

5475

How do you change the order of columns?

461

How will you create a bootstrap panel with heading?

5

where is the first engeenering college of Asia

1435

What is the use of auto format option?

321

How do I add a form to windows visual studio 2019?

413

What do you understand from in-memory computing? What is its significance in SAP HANA?

88

Is an api a web service?

341

How do I put windows 10 into safe mode?

475