How can we see the performance details about session run?

Saravanan Viswanathan

 Profile Answers by Saravanan Viswanathan Questions by Saravanan Viswanathan

• Nov 18th, 2010

By viewing the performance details 

Answer Question  Select Best Answer

What is a Source Qualifier?

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 2nd, 2010

Source qualifier is nothing?but a filter and it is an active transformation, it is used to join the data coming from homogeneous database the best practice of the mapping is using expression before other transformation after the source qualifier.

Answer Question  Select Best Answer

While reading flat files can we increase the default size of 1024 bytes of a line?If yes then is there any upper limit for that?

Sreenu

• Nov 19th, 2011

Yes, we can increase the line sequential buffer length in the session properties.

There is no hard limit actually, but when the block size and the DTM buffer size also should be increased to be able to process the records

Answer Question  Select Best Answer

Explain update strategy transformation giving an example

naveenkumar2829

 Profile Answers by naveenkumar2829 Questions by naveenkumar2829

• Dec 9th, 2010

By default Informatica processes all rows as insert, but if you want to change it as per transormation logic then we have to use updata strategy transformation.

Answer Question  Select Best Answer

What is High Availability in Informatica?

Suman Lohith Korrapati

 Profile Answers by Suman Lohith Korrapati Questions by Suman Lohith Korrapati

• Dec 20th, 2010

High availability is a PowerCenter option that eliminates a single point of failure in a domain and provides minimal service interruption in the event of failure.This is basically acheived at configur...

Answer Question  Select Best Answer

If incremental aggregation option is checked in session properties will the new cache is created during every run?

Thara Shri

• Feb 10th, 2012

Incremental aggregation creates a cache memory in the first run, in each successive runs, the cache is updated with new records( apart from the old records). Same cache but updated records. So you ha...

Answer Question  Select Best Answer

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

bpranayreddy

 Profile Answers by bpranayreddy Questions by bpranayreddy

• Jan 5th, 2011

Integration service will in turn call DTM service if the task in a session which will take care of extraction and loading of data......for other sessions like email, cmd it will hand over the task to DM manager which takes care of it. IS just manages the show

Answer Question  Select Best Answer

What are the different tracing levels and how it is used?

Kiran_U

 Profile Answers by Kiran_U Questions by Kiran_U

• Feb 23rd, 2012

A Tracing level determines the amout of the information in the session log.or it store the information in session log. we have 4 types of Tracing levels 1.normal,2.verbose,3.verbose data,4.terse defa...

Answer Question  Select Best Answer

How to join two tables when there is no matching colomns? What is the approch?

Ganesh

• Feb 2nd, 2016

We will create dummy port and data type is 1

Answer Question  Select Best Answer

Which scenario will use semi additive and factless fact tables?

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Feb 18th, 2011

Semi Additive Facts:A Semi Additive fact is a measure in a table that can be summed up w.r.to some dimentions and can not be or does not have any meaning if we sum up the measure with respect to those...

Answer Question  Select Best Answer

What is bridge table?

surendra

• Oct 11th, 2011

When we need to do many to many relation ship between dimensional table and fact table we can it as Bridge Table , simply we can bridge table sits between fact table and dimensional Table ..

Answer Question  Select Best Answer

What are the different types of partitons in Informatica?

• Oct 21st, 2011

Informatica partitions are used to improve the performance of power center through parallel data processing. The different types of informatica partitions are database partition, pass-through partitio...

Answer Question  Select Best Answer

In session level, What is the difference between Informatica 7 and 8

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

The main difference is

1) Architecture difference
2) Java trasformation has been introduced
3)user defined functions
4)dynamic configuration of cache and partitioning.

Answer Question  Select Best Answer

lpmca

 Profile Answers by lpmca Questions by lpmca

• Mar 22nd, 2011

DTM is Data Transformation Manager.  Integration Services are used to move data from source to target based on workflow and mapping metadata stored in the repository.Integration services will sta...

Answer Question  Select Best Answer

What is Load Manager? What is the use of it in Informatica. In which situations would you use it in realtime.

saithirumal

 Profile Answers by saithirumal Questions by saithirumal

• Mar 26th, 2011

if i run session or workflow that start an DTM process.the main purpose of Load Manager or Balance Load Manager is to find out which node is ideal among the nodes then assign the session task to that ...

Answer Question  Select Best Answer

hi, hi can anybody answer my query... that is i had a source table containing for eg;D1,D2,D3,D4,D5 one by one that means in a each column contains single source i.e., D1 in 1st col,D2 in 2nd col so on now i want in my target like D1-D2 in one col, D1-D2_D3 in other col,D2_D3-D4 in other col and D3-D4-D5 in other col plz send as soon as possible.......... thanx in advance

Ashish

• Jul 23rd, 2011

Use expression transformation to get the desired output

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

One can pass the input through the expression, where the variable/output ports can be configured to pass the combined value by using the CONCATENATION function of informatica.

Answer Question  Select Best Answer

Hi everyone ,Can u explain in detail what is a join index,with example.And what is its importance in teradata.

Read Best Answer

Editorial / Best Answer

rin23  

 Profile Answers by rin23 Questions by rin23

• Member Since May-2011 | May 12th, 2011

---

A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the way that it is used automatically by the database system to improve the performance of a query. Join indexes use the "classic" space-time trade off trading disk space for storage of the join index to get improved performance for queries. Unlike many other materialized view implementations, Teradata join indexes are updated immediately and automatically when changes are made to the base tables. There is never a concern that you might be using stale data when the system chooses to use a join index in the query plan. Also, Teradata uses its sophisticated coverage testing algorithm to minimize the cost associated with join index maintenance.?

rin23

 Profile Answers by rin23 Questions by rin23

• May 12th, 2011

A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the ...

Improve Answer

Can any body suggest the practical example where mapping parameter or variable is used, Please suggest the same for session parameter and variable..?

Rajeev Das

• Sep 2nd, 2011

Mapping Parameter is a constant value which remains same throughout the entire session, whereas Mapping variable value keeps changing as many times we run the session. Senario (mapping parameter), ...

Answer Question  Select Best Answer

One source is flat file and other source is oracle, then how do you do the mapping?

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

There are two possible ways of doing it: 1) Both used in a single mapping with single pipeline(Joiner can be used, in order to join both the source in the mapping) 2) Use two different pipelines in a ...

xitij7185

 Profile Answers by xitij7185 Questions by xitij7185

• Jun 13th, 2011

With joiner transformation .

Answer Question  Select Best Answer

please explain working with transactions in joiner transformations. What conditions are set. And any scenarios where it is used.

Sreenu

• Nov 19th, 2011

Please get this information from the Informatica help file( no one can give better than in help)

Let us if you are looking for the answer on any specific requirement

Answer Question  Select Best Answer