Most answered questions under tag informatica

+2 votes

3 answers

A table contains some null values. How to get (Not Applicable(NA)) in place of that null value in target?

posted Jul 31, 2015 by Sunil

+1 vote

3 answers

Informatica: Converting a table into multiple target tables based on one column.

posted Jun 9, 2014 by Jaineesh

+1 vote

2 answers

Which transformation should we use to normalize the COBOL and relational sources?

posted Mar 7, 2016 by Sachin

+2 votes

2 answers

Informatica: 1 lac or 100,000 of flat files in source how to load target at a time?

posted Jan 20, 2016 by Sachin

+2 votes

2 answers

Informatica: If Source Qualifier transformation populates two target tables, How to ensure TGT2 is loaded after TGT1?

posted Jan 11, 2016 by Sunil

+1 vote

2 answers

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u achieve using rank transformation ?

posted Oct 30, 2015 by Sachin

+1 vote

2 answers

What are the different tasks that can be created in workflow manager?

posted Oct 7, 2015 by Sachin

+2 votes

2 answers

Informatica: In unconnected lookup what are other transformations that can be used in place of expression transformation

posted Jul 24, 2015 by Sunil

+1 vote

2 answers

What is operational data source (ODS)?

posted Jun 8, 2015 by Amit Sharma

0 votes

2 answers

SQL Query in Informatica Cloud

posted Dec 30, 2014 by Amit Sharma

+2 votes

2 answers

informcatica workflow polling for a file under FTP location

posted Nov 17, 2014 by Ronu

0 votes

2 answers

Invalid Sessions Query of Informatica

posted Nov 11, 2014 by Sunil

+1 vote

2 answers

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

posted Nov 10, 2014 by Amit Sharma

0 votes

2 answers

How the expression transformation works?

posted Sep 22, 2014 by Sachin

+1 vote

2 answers

How to add column in existing oracle table with not null constraint

posted Sep 11, 2014 by Arun Gowda

0 votes

2 answers

How to get records with rank between 5 and 10

posted Sep 3, 2014 by Amit Sharma

0 votes

2 answers

Time value as output

posted Sep 2, 2014 by Sunil

0 votes

2 answers

Date conversion in informatica

posted Aug 12, 2014 by Sachin

0 votes

2 answers

Informatica Expression IIF

posted Jun 20, 2014 by Sachin

+1 vote

2 answers

Replacing special characters by null

posted Jun 12, 2014 by Sunil

+1 vote

2 answers

Hadoop as a substitue for ETL tools like SSIS, Informatica?

posted Jun 12, 2014 by Amit Sharma

+2 votes

2 answers

Informatica mapping creation

posted Jun 10, 2014 by Sachin

+1 vote

2 answers

Load data from a comp3 file to informatica

posted Jun 10, 2014 by Amit Sharma

+1 vote

2 answers

Informatica Expression Convert String to Date

posted Jun 9, 2014 by Sachin

+1 vote

2 answers

Informatica Unconnected Lookup parse error

posted Jun 9, 2014 by Amit Sharma

+1 vote

2 answers

Dynamic operators in where clause in Informatica?

posted Jun 7, 2014 by anonymous

+1 vote

2 answers

Informatica: Get the name of previous task from current task?

posted May 27, 2014 by Pooja Bhanout

+2 votes

2 answers

How to Rename the ODBC Data source in Import tables->connect to database in informatica?

posted May 26, 2014 by Madhavi Kumari

+2 votes

2 answers

Need help on Informatica Scenario

posted May 23, 2014 by Rohini Agarwal

+1 vote

2 answers

Informatica Date/Time Conversion

posted May 12, 2014 by Madhavi Kumari

+1 vote

2 answers

How to update data in a non primary key table

posted May 12, 2014 by Pooja Bhanout

+1 vote

2 answers

How to map the informatica for the inserts and updates to the target from source table?

posted May 9, 2014 by Pooja Bhanout

+1 vote

2 answers

PDF Data source in Informatica

posted May 9, 2014 by Rohini Agarwal

+2 votes

2 answers

How to add an intermediate calculated “variable” in informatica

posted May 6, 2014 by Madhavi Kumari

+2 votes

2 answers

Informatica Lookup & Update strategy error

posted Apr 25, 2014 by Rohini Agarwal

+2 votes

2 answers

Error while reading source file name starts with a number in informatica

posted Apr 23, 2014 by Pooja Bhanout

+1 vote

2 answers

Case Statements/Decode Function in Informatica

posted Apr 11, 2014 by Rohini Agarwal

+1 vote

2 answers

How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

posted Apr 4, 2014 by Madhavi Kumari

+2 votes

2 answers

How do I change the color of inactive fields in Informatica's edit windows?

posted Mar 27, 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

2 answers

Informatica update partial data using UPDATE strategy

posted Mar 18, 2014 by Pooja Bhanout

+3 votes

2 answers

Specifying Source file name using parameter variables in informatica 9?

posted Mar 13, 2014 by Rohini Agarwal

+4 votes

2 answers

Local repository in Informatica 9.1

posted Mar 12, 2014 by Madhavi Kumari

+4 votes

2 answers

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

posted Mar 12, 2014 by Rohini Agarwal

+3 votes

2 answers

What is the difference between $ vs $$ Informatica parameters?

posted Mar 10, 2014 by Madhavi Kumari

+2 votes

2 answers

Difference between Joiner and Union Transformation

posted Mar 10, 2014 by Pooja Bhanout

+1 vote

2 answers

Join multiple tables located in different databases using Informatica

posted Mar 10, 2014 by Rohini Agarwal

+1 vote

2 answers

Overload of session log in informatica

posted Mar 7, 2014 by Pooja Bhanout

+1 vote

2 answers

How do I Exclude matching rows in two flat files usign Informatica?

posted Mar 4, 2014 by Pooja Bhanout

+5 votes

2 answers

How to extract number from a string in Informatica?

posted Feb 5, 2014 by Dewang Chaudhary