can we have an unconnected lkp to lookup a DB2 record
against a Teradata record?

Answer Posted / winithra

Hi,
we can use an unconnected lookup to lookup on any DB
because we specify the connection string details in the
lookup transformation !

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1624


Explain some differences between mpp and smp?

595


How to run a query in teradata?

588


How is MLOAD Client System restarted after execution?

604


Give the sizes of SMALLINT, BYTEINT and INTEGER.

668






Difference between stored procedure and macro?

691


What is oltp?

574


What are the different design perspectives used in teradata?

554


What are default access rights in teradata? What explicit right can be given to a user?

656


What are aggregate tables? How do you design them using teradata?

638


How can you track login parameters of users in teradata?

638


What is collect statistics?

591


When tpump is used instead of multiload?

633


Explain the advantages of partitioned primary index in a query?

567


What is upsert statement in teradata?

618