Question { CTS, 31633 }

What is FILLER command in Teradata?

Answer

ok Girish,
can u send the SYNTAX for Filler command

Question { Infosys, 29172 }

how can we load first and last record from a flat file
source to target?

Answer

I have an IDEA,
After sql Trans,go with AGG,RANK transformation,
in RankTrans Properties set the rank 1 only---1 row returns,
In AggTrans Dont do any column for Group--Last row returns,
We need 2 Target tables. 1 for 1st record,2 for last record,
if u using the UNIONtrans one Target table is enough,,,
i think it wii help u,,,,,,srinu,,,,,,,,,

Question { Infosys, 29172 }

how can we load first and last record from a flat file
source to target?

Answer

Hi,,, Vinod, As per your Solution we have to check
complete data Table for ,,

syntax for 1st,last:::

FIRST( ITEM_NAME, ITEM_PRICE > 40 )

FLOOR( PRICE )

ok,,,
Any corrections Let me Know,,,
srinu.srinuvas@gmail.com

Question { KPIT, 7859 }

1:when we develop a project what are the performance issue
will raise?? KPIT
2:if a table have INDEX and CONSTRAINT why it raise the
performance issue bcoz when we drop the index and disable
the constraint it performed better??KPIT
3:what are unix commands frequently used in informatica??

Answer

Hai KPIT,, My Ans will Show you the Way,,,,,,

1) Performance Issue in Informatica: In your
Project ,My Project,,,Any Project Mostly our final
Target was Loading the Data in to Target Table, under
Efficiently in Less time.
Tune the Mapping, Less Active Transformations,Use Best
Loading Option,
Partition the Data,Index less Target Table,,,,,


2)Yes, we drop the index and disable the constraint Perform
Better,That loads the Data based on the Particicular Table
only,Else I will go for Parent,Child test in FK
Relation,Condition in constraint,,,After Loading the Data
You can Configure indexes, constraints on Table.


3)SED-commands,AWK-commands,Dir Commands,File Commands,Copy
Commands only,,

Thanks
Srinu.srinuvas@gmail.com

Question { 16583 }

Can any one plz provide the teradata interview questions?

Answer

send ur
Test mail to srinu.srinuvas@gmail.com

Question { 15879 }

What are partitions in informatica and which one is used
for better performance?

Answer

Pipeline Partitioning Overview
Configuring Partitioning Information
Cache Partitioning
Round-Robin Partition Type
Hash Keys Partition Types
Key Range Partition Type ---BestPerformance
Pass-Through Partition Type
Database Partitioning Partition Type
Partitioning Relational Sources
Partitioning File Sources
Partitioning Relational Targets
Partitioning File Targets
Partitioning Joiner Transformations
Partitioning Lookup Transformations
Partitioning Sorter Transformations
Mapping Variables in Partitioned Pipelines
Partitioning Rules

Question { 20037 }

How Union Transformation is an Active Trans?

Answer

Hi, Krishraj,
un-common records mean,,,,(Syntax based,Datatype based,...)
?

Hi, Sharad Sharma
By default it will follow UNION ALL Functionlity.
It will allows Duplicate also.
?

Thanks for Replay!
N.srinu

Question { PCS, 12245 }

What is a surrogate key?Why we use it in a mapping?Pl give
an example.

Answer

surrogate key is a System generated Key ( Artificial
key ),Every join between dimension tables and fact tables
in a data warehouse environment should be based on
surrogate keys, not natural keys.
There are still more reasons to use surrogate keys. One of
the most important is the need to encode uncertain
knowledge. You may need to supply a customer key to
represent a transaction, but perhaps you donýt know for
certain who the customer is. This would be a common
occurrence in a retail situation where cash transactions
are anonymous, like most grocery stores.
What is the customer key for the anonymous customer?
Perhaps you have introduced a special key that stands for
this anonymous customer. This is politely referred
to as a "hack."

Question { CSC, 8162 }

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,

Answer

oracle support range
Jan 1, 1753 AD
to
Dec 31, 9999 AD

in informatica
The default date display format is
DY MON DD HH 24:MI:SS YYYY.
When you specify a date display format,
it displays in the test window. An invalid date display
format is marked invalid.

if u not able to Understand,,,,

Please send the Question Clearly,,,,srinu

Question { CSC, 34158 }

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

Answer

The main Data sorces for Informatica,,,

1)Relational Databases,,like(oracle,Teradata,Sql server,,,)

2)Flat File (data in a Notepad(Text format)) in a
Perticular path.



srinu,,,,,

Question { 7460 }

I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You

Answer

passive transformation :
unable to keep a condition,Expressions only.

active transformation :
unable to keep a Expressions,condition only.

Based on Transformation functionality.

Question { 18388 }

What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?

Answer

conn LKP Trans CACHE Reusable with Persistent caache
option.
Conn lkp supports Default value.

---------

UNCONN LKP Trans CACHE not reusable.
UNCONN LKP Trans Not support Default value.

Question { 7130 }

Hi all, i am new to this site and new to Informatica too. I
have few questions regarding that.
1) When we load flat files into target tables how do we
identify duplicates? and where do load the duplicate
records for further reference?
2) How do we do chage data capture? Is this Slowly changing
Dimension technique?


Thanks in Advance

Answer

--When we load flat files into target tables how do we
identify duplicates?

I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans
(I think “it will help u” Any ,,,Let me know,,
srinu.srinuvas@gmail.com)


--where do load the duplicate records for further
reference?

From 2nd router Transfromation we have a Separate Target
Table.

--How do we do chage data capture? Is this Slowly changing
Dimension technique?
chage data capture(CDC) Mean newly Inserts, Updates
Based on Data loading time,,

This Inserts, Updates only Slowly changing Dimension
technique.

Question { Infosys, 7617 }

Hey I am net to informatica? Can any one explain me step by
step How scd will work ?

Answer

Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.

Question { 7673 }

Can anyone know that what is the Source File limitation in
Informatica?
To be more precise ..
how many flat file we can use as a source in a mapping if..
1) The Structure of flat files are same
&
2) If the Structure of flat files are different.
Please explain the procedure also if it dosn't bother one much!!

Answer

There is no limit for no of sources,

Flat file(same syntax,Diff Syntax) and Relational also.