How to move the Ab initio graph development to Production or QA?

Sai

• Aug 14th, 2018

We have to deploy using the tag creation, from dev environment to other environment.
Syntax :: air tag create tagname -file filename -exact

Aman Sharma

• May 19th, 2018

We can create tag to move the graph from dev to other environment.
Air create tag /Path/

Answer Question  Select Best Answer

Priyanka Sathe

• May 8th, 2018

Teradata is a RDBMS used specially to build data warehousing applications.
The biggest strength of TD is parellelism.
TD distributes its workload evenly across its system and process it in parallel which makes it much faster than other databases.

Martin Alvarez

 Profile Answers by Martin Alvarez Questions by Martin Alvarez

• Mar 19th, 2012

Teradata and Oracle produce relational database management systems. What the previous answers do not provide are important facts about both platforms. Teradata products are a "combo" of hardware + so...

Answer Question  Select Best Answer

How to read nth Row from a File using Sequential File Stage in Datastage
Scenario is as follows:
I have only two stages in a job
SeqFileStage1------> SeqFileStage2
I have to read only 6th Row from File 1 and write it in File2.

Biswajit Rath

• Mar 11th, 2018

We can solve the question by using the head as well as the tail command. So let me explain the answer for finding the nth line by using both the head and tail command. head -nthline fileName | tail -...

Krishna

• Sep 19th, 2017

In sequential file, Use the filter command head -6|tail -1

Answer Question  Select Best Answer

I have a file with 1000 rows I need to split this file that each 100 row is split by a header, to make more clear I need to concatenate the header after 100 row

Harsha

• Feb 7th, 2018

Take the input to sequential file ,in that in filter opinion mention head -100 and output connect it to column import where you mention the schema of input and mention the output schema u need ..so it concatenates entire thing into single row/column.

Correct me if im.wrong.

Answer Question  Select Best Answer

nareshcnr

 Profile Answers by nareshcnr Questions by nareshcnr

• Nov 6th, 2017

Types of Dimension tables : There are mainly three types of dimension tables available in case of Slowly Changing Dimensions Type 1: Never maintain historical data. only update the existing data. e...

Johnny

• Aug 31st, 2017

The following are the type of dimensions
Slowly changing
Fast Changing
Inferred
Junk
Conformed
Degenerate, and
Static

Answer Question  Select Best Answer

Shaheryar Dilawer

• Jul 25th, 2017

Dimension table has to be recorded before the creation of fact table.
The fact table mainly consists of business facts and foreign keys that refer to primary.

Shaheryar Dilawer

• Jul 25th, 2017

A dimension table consists mainly of descriptive attributes that are textual fields. A dimension table contains a surrogate key, natural key, and a set of attributes. The fact table mainly consists of business facts and foreign keys that refer to primary.

Answer Question  Select Best Answer

What is the output (number of records)?
Table A with one column values (1,1,2,2,2,3,4,5)
Table B with one column values (1,1,1,2,2,3)
1. A Union B
2. A Intersection B
3. (A Union B) minus (A intersection B)
4. A Minus B
5. A Inner Join B
6. A Left Join B
7. A Right Join B
8. A Full Join B
9. A Outer Join B

shaili

• Mar 2nd, 2017

A union B : 1,2,3,4,5
a intersection b:1,2,3
a union b minus a intersection b :4,5
a minus b : 4,5
a inner join B :1,1,1,1,1,1,2,2,2,2,2,2,3
a left join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5
a right join b :1,1,1,1,1,1,2,2,2,2,2,2,3
a full join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5

ram

• May 30th, 2016

1. Union:(1,1,2,2,2,3,4,5)
2. Intersection:(1,1,2,2,3)
3. ::(2,4,5)
4. Aminus b:(2,4,5)

Answer Question  Select Best Answer

my Source is like:

Sno Name
1 XXXX
2 YYYY

I want the Target like:

Sno Name Frequency
1 XXXX 1
2 YYYY 2
2 YYYY 2

How can I replicate the "2 YYYY".
I am supposed to make it dynamic for all possible frequencies.

Visal

• Aug 14th, 2016

From what I understood from the scenario given above, you want to duplicate some particular type of record. use Router and write the same condition (say column1=2) for both output group. Remember defa...

Answer Question  Select Best Answer

How union transformation is active?

jignesh

• Jan 2nd, 2015

No doubt union transformation will give you the result as a passive transformation with same number of records,But row number of the records will get changed in output result set.....eg we have table ...

Answer Question  Select Best Answer

Which type of relation between fact and dimension table in star schema and snowflake schema?like one to one or many to many?

naveen

• Dec 16th, 2014

Parent, child relation between fact,dimensions in star schema,snow flake schema

vveeralapati

 Profile Answers by vveeralapati Questions by vveeralapati

• Apr 25th, 2013

For one dimension record, you will see many fact records associated.Many to one or one to many relationship is not to be confused with number of records or columns in a table. that has nothing to do with a relation

Answer Question  Select Best Answer

Harsh

• Dec 2nd, 2014

Alter index rebuild;

Answer Question  Select Best Answer

What is the main difference between Primary Index and Primary key in teradata? and can we have this two on same column?

uday

• Oct 13th, 2014

Primary Index in Teradata is used for loading and extracting the data from Database. (TD will load data Through PI
) and other hand PK is cluster index uniqe identifier. Pk will not allow Null and duplicates but for PI ok

Agnes Melbin R

• Apr 11th, 2013

If i am not wrong , both the titles should be swapped from the above answer as follows , Primary Key --Always Unique --Does not allow NULL values --Optional for a table --Values cant be updated --Doe...

Answer Question  Select Best Answer

How do you handle the changing no of files as source in the mapping/session which loads the data in a Relational table

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 26th, 2014

If all the files are of the same structure, then we can use the INDIRECT File option. In the indirect file name, give all the sourec file names. Informatica will ftech data from all the source files mentioned in the indirect file.

Kaavya

• Jun 3rd, 2014

Using Indirect file load option

Answer Question  Select Best Answer

Explain why database design is important?

LiamWhales

 Profile Answers by LiamWhales Questions by LiamWhales

• Mar 24th, 2014

Database design is the key to a successful database. It reduces the amount of redundant data within the database along with correctly sized columns for minimal space usage whilst ensuring longevity. W...

Sheraz Baig

• Nov 25th, 2013

Database Design is the document which shows the flow of data, its functionality and relationship between tables. This document is very important during database development period , and after the comp...

Answer Question  Select Best Answer

Liam Whales

• Mar 24th, 2014

Anything that can always be uniquely generated and bears no relation on the underlying data

Aswin

• Feb 4th, 2014

Why cant we use a GUID? which is more powerful and have good uniqueness

Answer Question  Select Best Answer

Liam Whales

• Mar 24th, 2014

Moving from one software or hardware platform to another. Rather than the usual functional changes the aim is to keep the system functionally the same but move to the new platform.

JavidJaffer

• Jan 14th, 2014

System Conversion: is a common layman word, which has meany meanings to it: It can be: 1. Either Hardware Upgrade (Machines, Servers, LAN, Router, Switches) due to their Expansions in terms of volume...

Answer Question  Select Best Answer

Sheraz Baig

• Nov 25th, 2013

Cube is basically the extension used with group by class to get the subtotals of the group. If "n" is the number of columns listed in the CUBE, there will be 2n subtotal combinations.
Syntex is :
GROUP BY CUBE ()

Answer Question  Select Best Answer

What is external table in oracle?How oracle read flat file?

sheraz baig

• Nov 20th, 2013

External Tables let you query data in a flat file. In 9i, only read operations were permitted; in 10g, you can also write out data to an external table. While external tables can be queried, theyre no...

Answer Question  Select Best Answer

Karthikeyan E

• Oct 21st, 2013

RAID 1 --- Additional disk which stores the mirror image of original disk data.

RAID 5 - Uses XR algorithm and retrieves records when original disk failure.

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Jan 4th, 2008

The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk). Cheers,Ravi Kumar Garre

Answer Question  Select Best Answer

What are the types of dimensions? Can you explainthe each type in short?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

Conformed Dimension: Used across lines of businesses to gather information from across LOBs. Eg. if we want to know the deptnames where the avg salary of employees is more than the overall avg. Junk D...

Joe

• Aug 21st, 2012

1. Conformed Dimensions
2. Junk Dimensions

Answer Question  Select Best Answer