Most viewed questions under tag informatica

+2 votes

2 answers

load multiple columns data into single column in informatica?

posted Aug 19, 2013 by anonymous

+1 vote

1 answer

Script runs in Unix but not in Informatica command task

posted Sep 12, 2014 by Sachin

+2 votes

1 answer

Whats the benifit of creating table definition manually in informatica (Source Analyzer) instead of importing

posted Apr 17, 2014 by Madhavi Kumari

+5 votes

2 answers

How to extract number from a string in Informatica?

posted Feb 5, 2014 by Dewang Chaudhary

+1 vote

1 answer

What is incremental loading in Informatica?

posted Jun 1, 2015 by Sunil

+1 vote

1 answer

How to write low value and high value in power exchange target in informatica?

posted Jul 22, 2014 by anonymous

+1 vote

1 answer

How to get row_number() in informatica

posted Mar 5, 2014 by Madhavi Kumari

+1 vote

1 answer

What is a Decode in Informatica?

posted Feb 24, 2016 by Sachin

+1 vote

1 answer

What is complex mapping in informatica

posted May 6, 2015 by Sachin

+2 votes

2 answers

Difference between Joiner and Union Transformation

posted Mar 10, 2014 by Pooja Bhanout

+1 vote

2 answers

Informatica Date/Time Conversion

posted May 12, 2014 by Madhavi Kumari

+1 vote

2 answers

Case Statements/Decode Function in Informatica

posted Apr 11, 2014 by Rohini Agarwal

+1 vote

1 answer

How to convert the date format 'MM/DD/YY' to 'DD-MMM-YYYY'

posted Jun 18, 2014 by Amit Sharma

+1 vote

2 answers

Informatica Unconnected Lookup parse error

posted Jun 9, 2014 by Amit Sharma

+2 votes

1 answer

How you know when to use a static cache and dynamic cache in lookup transformation?

posted Jul 13, 2015 by Amit Sharma

+2 votes

2 answers

update a record in target table without using Update strategy using Informatica

posted Aug 19, 2013 by Luv Kumar

+1 vote

1 answer

Informatica: How to generate sequence numbers using expression transformation?

posted Mar 14, 2016 by Amit Sharma

+2 votes

1 answer

Database driver error when loading data with Informatica into Oracle XE 10 g

posted Oct 13, 2014 by Sunil

0 votes

1 answer

Informatica services on local computer start and stops

posted Dec 29, 2014 by Amit Sharma

+1 vote

2 answers

When to use MLOAD, FLOAD and TPT connections in informatica?

posted Nov 10, 2014 by Amit Sharma

+2 votes

1 answer

INFORMATICA LOADING ERROR

posted Apr 21, 2014 by Madhavi Kumari

+2 votes

2 answers

How to convert string into number using expression transformation in informatica?

posted Mar 21, 2014 by Rohini Agarwal

+1 vote

1 answer

Standard datatypes of Informatica

posted May 2, 2014 by Pooja Bhanout

+1 vote

1 answer

How to transform rows into column using Normalizer in Informatica?

posted Aug 14, 2013 by Sumit Pokharna

+1 vote

1 answer

Give a difference between a powerhouse and a repository server?

posted Feb 27, 2015 by Amit Sharma

+2 votes

1 answer

The Repository Service marked the session or session instance as impacted

posted Dec 23, 2014 by Sunil

0 votes

1 answer

Informatica Repository Query to get Workflow, Session, Mapping and Source/Target of Mapping

posted Jul 3, 2014 by Sachin

+3 votes

1 answer

Define the term surrogate key?

posted Mar 12, 2015 by Sachin

0 votes

1 answer

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

posted May 11, 2015 by Amit Sharma

+1 vote

1 answer

While installing Informatica gretting Error:Command to create the domain failed

posted May 6, 2014 by Rohini Agarwal

+2 votes

1 answer

What is the difference between OLTP and ODS?

posted Aug 6, 2015 by Sunil

0 votes

1 answer

REP_51002 Failed to logon to Databse Server, ORA-12154: TNS:could not resolve the connect identifier specified

posted Aug 18, 2014 by Ela

+1 vote

2 answers

Join multiple tables located in different databases using Informatica

posted Mar 10, 2014 by Rohini Agarwal

+2 votes

1 answer

Can PowerCenter write directly to a JSON target?

posted Nov 7, 2014 by Sunil

+1 vote

2 answers

How to update data in a non primary key table

posted May 12, 2014 by Pooja Bhanout

+2 votes

1 answer

Informatica — How to convert 'DD-MON-YY' to DD/MM/YYYY

posted Aug 19, 2016 by Info Data

+2 votes

0 answers

Converting time stamp in informatica to date

posted Apr 26, 2016 by anonymous

0 votes

1 answer

Informatica error =[ERROR('transformation error')]

posted Aug 12, 2014 by Sunil

0 votes

1 answer

find the list of mapping and workflow affecting the particular table in informatica

posted Jan 13, 2015 by Amit Sharma

+1 vote

1 answer

How to truncate a string in informatica based of size instead of length

posted Aug 24, 2013 by anonymous

+2 votes

1 answer

Informatica: Pass date value from one session to another session in the same workflow

posted Nov 10, 2014 by Ronu

+3 votes

2 answers

Specifying Source file name using parameter variables in informatica 9?

posted Mar 13, 2014 by Rohini Agarwal

+2 votes

1 answer

Informatica: how to get the auto-generated primary key of a table in Informatica mapping?

posted Oct 17, 2014 by Amit Sharma

+2 votes

1 answer

What is a dynamic session partition in Informatica?

posted Feb 10, 2016 by Sachin

+3 votes

1 answer

Informatica: How are indexes created after completing the load process?

posted Feb 1, 2016 by Sachin

+1 vote

1 answer

How can we create header and footer in target using informatica?

posted Mar 2, 2016 by Amit Sharma

+1 vote

2 answers

Replacing special characters by null

posted Jun 12, 2014 by Sunil

0 votes

1 answer

Java API for Informatica

posted Jul 18, 2014 by Sunil

+2 votes

0 answers

Informatica: PWX-02142 Field extends past end of record.

posted Aug 28, 2015 by anonymous

+1 vote

1 answer

How to lookup is acting as both active and passive ? how is it possible?

posted Aug 11, 2015 by Sunil